#!/bin/sh 

## The shell script for backup db data

DB_USER='root'
DB_PWD='nian123'
SCHEMA='nian'

BACK_DIR='/home/ada/data/nian/backup/db'
BAK_FILE_NAME="nian-bak-`date +%Y%m%d`.sql"

mysqldump -u$DB_USER -p$DB_PWD $SCHEMA > $BACK_DIR/$BAK_FILE_NAME

